THIS DIALOG BOX IS FOR ENTERING THE NEW PRICE FOR EVERY STOCK OR MUTUAL FUND YOU OWN. THIS IS THE PRICE YOU FIND IN THE WALL STREET JOURNAL.
"IF YOU HIT CANCEL AT ANY TIME, THE MACRO STOPS TAKING DATA, AND UPDATES YOUR ENTIRE PORTFOLIO."
*2 PORTFOLIO SUMMARY DIALOG BOX
THIS IS THE DIALOG BOX OF MY PORTFOLIO SUMMARY. THIS ONLY INCLUDES OPEN TRADES.
*3
"IF YOU ARE READING THIS HELP, THEN YOU SHOULD BE ADDING A STOCK OR MUTUAL FUND TO YOUR PORTFOLIO THAT YOU DON’T OWN NOW."
"IF YOU WANT TO ADD TO A STOCK OR MUTUAL FUND THAT YOU ALREADY OWN, THEN CHOOSE “TRANSACTION ON AN ITEM...” FROM THE MRC MENU."
YOU CAN OMIT THE P/E AND THE 52 WEEK HIGH AND LOW IF YOU DON’T HAVE THAT INFORMATION.
BE SURE TO SELECT THE RIGHT EXCHANGE.
*4
THIS IS THE DIALOG BOX WERE YOU TELL THE PROGRAM HOW TO ADD TO A STOCK OR MUTUAL FUND THAT YOU ALREADY OWN.
"IF YOU WANTED TO ADD A BRAND NEW STOCK OR MUTUAL FUND (ONE THAT YOU DID NOT OWN BEFORE), THEN SELECT “ADD TO A PORTFOLIO...” FROM THE MRC MENU."
REMEMBER THAT YOU MUST SELECT A STOCK OR FUND FROM THE LIST THAT APPEARS IN THE DIALOG BOX.
"THE DATE IS THE DATE OF THE TRANSACTION, NOT NECESSARILY TODAY’S DATE."
"BE SURE AND SELECT THE TYPE OF TRANSACTION (NEW PURCHASE, DIVIDEND, OCP, OR SPLIT)."
*5
THIS IS A REPEAT OF THE INFORMATION YOU JUST ENTERED.
"IF YOU WANT TO GET OUT OF THIS ALTOGETHER, CLICK ON “START OVER...”, AND CANCEL OUT OF THE DIALOG THAT APPEARS."
*6
THIS IS A DIAGNOSTIC LIST OF THINGS THAT MIGHT GO WRONG. CLICK ON AN ITEM.
*7
"WHEN DELETING A STOCK OR FUND, MAKE SURE YOU PUT THE DATE IN MM/DD/YY FORMAT. YOU DO NOT NEED THE DOLLAR SIGN FOR THE PRICE OR THE FEES."
"IF YOU MAKE AN ERROR,YOU WILL GET A CHANCE TO FIX IT."
*8
"IF ANY OF THE INFORMATION YOU SEE IS WRONG, THEN HIT THE START OVER BUTTON"
OTHERWISE HIT THE CONTINUE BUTTON
*9
THIS DIALOG BOX DISPLAYS THE FINAL RESULTS RELATED TO THE ITEM THAT YOU ARE LIQUIDATING.
"IF ANYTHING LOOKS STRANGE OR ILLOGICAL, THEN HIT THE “CANCEL” BUTTON, AND YOU WILL BE ABLE TO START OVER."
*10
YOU MUST SELECT A PORTFOLIO BEFORE CONTINUING WITH THE COMMAND THAT YOU SELECTED.
"IF YOU ARE TRYING TO EDIT A PORTFOLIO BY ADDING A NEW ITEM, THEN BE SURE TO CHECK THE APPROPRIATE BOX BEFORE CLICKING THE “OK” BUTTON."
*11
YOU AVE ASKED TO EDIT A PORTFOLIO. YOU HAVE THE FOLLOWING OPTIONS:
1) DELETE THIS ITEM: COMPLETELY REMOVES THE ITEM SELECTED FROM THE LIST ON THE LEFT SIDE OF THE DIALOG BOX FROM THE PORTFOLIO. YOU WILL BE GIVEN AN OPPORTUNITY TO CANCEL THIS ACTION IF YOU DISCOVER THAT YOU DID NOT MEAN TO DO THIS.
2) NEW TRANSACTION ON THIS ITEM: FOR MAKING A NEW TRANSACTION ON THE ITEM SELECTED FROM THE LIST ON THE LEFT SIDE OF THIS DIALOG BOX. YOU WILL BE GIVEN AN OPPORTUNITY TO CANCEL THIS ACTION IF SELECTED BY MISTAKE.
"3) VIEW/EDIT/DELETE A TRANSACTION: THIS OPTION WILL ALLOW YOU TO MAKE CHANGES IN ANY TRANSACTION THAT YOU HAVE ALREADY RECORDED, INCLUDING DELETING THE TRANSACTION ALTOGETHER. YOU WILL BE ABLE TO CANCEL THIS ACTION IF YOU SELECTED IT BY MISTAKE."
"4) INSERT A TRANSACTION: IF YOU HAVE ENTERED A SERIES OF TRANSACTIONS, AND THEN DISCOVER THAT YOU NEED TO ENTER A TRANSACTION IN THE MIDDLE OF THE SERIES, THIS IS THE OPTION TO CHOOSE. YOU WILL BE ABLE TO CANCEL THIS ACTION IF SELECTED BY MISTAKE."
*12
THE TRANSACTIONS IN THE ITEM THAT YOU HAVE SELECTED ARE LISTED BY DATE.
"IF THERE IS MORE THAN ONE TRANSACTION ON A GIVEN DATE, AND YOU ARE NOT SURE WHICH ONE YOU WANT, THEN SIMPLY SELECT ANY ONE. IF IT IS THE WRONG ONE, YOU WILL GET A CHANCE TO CANCEL YOUR REQUEST AND START OVER."
*13
"THIS IS THE DIALOG BOX WHERE YOU ARE ALLOWED TO EITHER ENTER INFORMATION RELATED TO A BRAND NEW TRANSACTION, OR VIEW/EDIT/DELETE A TRANSACTION THAT YOU ALREADY ENTERED."
BE SURE TO CHECK THE APPROPRIATE BOX IF YOU ARE SURE THAT YOU WANT TO DELETE THE TRANSACTION DISPLAYED.
*14
"THIS DOCUMENT CONTAINS CURRENT, CORRECT INFORMATION ABOUT THE PORTFOLIO. HOWEVER, NOT EVERY TRANSACTION IS RECORDED ON THIS WORKSHEET."
ALL TRANSACTIONS RELATED TO A PARTICULAR STOCK OR MUTUAL FUND ARE RECORDED IN A WORKSHEET THAT IS LINKED TO THIS WORKSHEET.
"THIS MACRO WILL AUTOMATICALLY OPEN ALL STOCK, MUTUAL FUND, OR OTHER WORKSHEETS THAT ARE LINKED TO THIS PORTFOLIO. DOING SO WILL NOT AFFECT ANY OF THE MACROS."
IT IS STRONGLY SUGGESTED THAT YOU DO NOT MAKE ANY CHANGES IN ANY OF THESE DOCUMENTS UNLESS YOU KNOW WHAT YOU ARE DOING!
IT IS ALSO A GOOD IDEA TO CLOSE ALL OF THESE DOCUMENTS WHEN YOU ARE FINISHED LOOKING AT THEM WITH THE “CLOSE ALL DRIPS ONLY” COMMAND FROM THE MRC MENU.
*15
THIS IS THE RECOMMENDED WAY TO OPEN A SINGLE DOCUMENT THAT IS LINKED TO ANY PORTFOLIO.
IT IS STRONGLY SUGGESTED THAT YOU DO NOT MAKE ANY CHANGES IN ANY DOCUMENT UNLESS YOU KNOW WHAT YOU ARE DOING!
IT IS ALSO A GOOD IDEA TO CLOSE THIS DOCUMENT WHEN YOU ARE FINISHED LOOKING AT IT WITH THE “CLOSE ALL DRIPS ONLY” COMMAND FROM THE MRC MENU.
*16
"THIS IS THE WAY TO EITHER ENSURE THAT A CERTAIN PORTFOLIO IS OPENED EVERY TIME THAT YOU START THIS PROGRAM, OR ENSURE THAT A CERTAIN PORTFOLIO IS NEVER OPENED WHEN YOU START."
"IF YOU MAKE A DECISION EITHER WAY, YOU CAN ALWAYS CHANGE YOUR MIND BY RUNNING THIS COMMAND AGAIN."
"KEEP IN MIND THAT ANY CHANGES THAT YOU MAKE WILL NOT TAKE EFFECT UNTIL YOU START THIS PROGRAM AGAIN. YOU NEED NOT RESTART YOUR COMPUTER, NOR DO YOU NEED TO RESTART MICROSOFT EXCEL."
*17
YOU SHOULD USE THIS MACRO WHEN YOU WANT TO ENTER THE CURRENT PRICES FOR ALL OF THE ITEMS IN YOUR PORTFOLIO.
"A SEPARATE DIALOG BOX WILL APPEAR FOR EACH ITEM. YOU MAY CANCEL AT ANY TIME, HOWEVER, IF YOU DO, ANY PRICE THAT YOU ENTERED FOR A PREVIOUS ITEM WILL BE RETAINED."
"WHEN YOU ARE FINISHED (OR IF YOU HIT CANCEL), THIS MACRO WILL CHECK ALL STOCKS OR FUNDS FOR A NEW 52 WEEK HIGH OR LOW, UPDATE YOUR PORTFOLIO SUMMARY, AND DISPLAY THAT SUMMARY TO YOU."
THIS MACRO WILL ALSO SAVE THE CURRENT PORTFOLIO.
*18
THIS MACRO WILL CALCULATE THE ANNUALIZED RETURN ON EACH ITEM IN ANY PORTFOLIO THAT YOU CHOOSE.
"THIS IS A TASK THAT WOULD ORDINARILY SLOW DOWN THE PERFORMANCE OF THE PROGRAM QUITE DRASTICALLY, WHICH IS WHY YOU MUST ASK FOR IT USING THIS SEPARATE COMMAND."
"IF YOU HAVE MORE THAN A FEW ITEMS IN ANY PORTFOLIO, PLEASE BE PATIENT. THIS COMMAND WILL CALCULATE ANNUAL RETURNS AT A RATE OF ABOUT 20 SECONDS PER ITEM ON A MACINTOSH LC."
*19
"WHEN MAKING A BRAND NEW PORTFOLIO, YOU WILL FIRST BE ASKED TO GIVE IT A NAME. THEN, YOU WILL BE AUTOMATICALLY DIRECTED TO ENTER AN ITEM INTO THE NEW PORTFOLIO."
*20
THIS COMMAND SHOULD BE USED TO MAKE ANY CHANGES TO ANY PORTFOLIO.
"YOU WILL BE ABLE TO ADD ITEMS TO, AND REMOVE ITEMS FROM A PORTFOLIO. YOU WILL ALSO BE ABLE TO ENTER OR REMOVE TRANSACTIONS IN ANY ITEM THAT ALREADY EXISTS IN ANY PORTFOLIO."
"FURTHER, YOU WILL BE ABLE TO VIEW AND/OR EDIT ANY TRANSACTION THAT YOU MADE IN ANY ITEM, AND YOU WILL HAVE THE ABILITY TO INSERT A TRANSACTION ANYWHERE IN ANY PORTFOLIO."
"IF ANY OF THE DIALOG BOXES ARE UNCLEAR, YOU CAN REFER TO MORE HELP WHEN YOU SEE THEM ON YOUR SCREEN."
*21
THIS COMMAND WILL FIND AND CLOSE EACH DOCUMENT THAT IS LINKED TO THE PORTFOLIO THAT YOU SPECIFY.
OTHER DOCUMENTS WILL REMAIN UNTOUCHED.
"IN THE COURSE OF THIS MACRO, ALL OPEN DOCUMENTS WILL BE CALCULATED. THIS MAY TAKE A WHILE IF THERE ARE MANY DOCUMENTS OPEN."
*22
"THIS MACRO WILL CLOSE ALL DOCUMENTS THAT ARE LINKED TO PORTFOLIOS, INCLUDING EXTRANEOUS EXCEL DOCUMENTS."
"IF YOU HAVE ANY EXCEL DOCUMENT THAT IS HIDDEN, THEN IT WILL NOT BE CLOSED BY THIS MACRO."
*23
THIS MACRO WILL CLOSE ALL DOCUMENTS AND REMOVE THE MRC MENU.
"TO START OVER, OPEN STOCKS MACRO AGAIN."
*24
THIS COMMAND WILL SWITCH BETWEEN TWO MODES OF OPERATION WHENEVER YOU USE ANY OF THE OTHER COMMANDS IN THE MPM MENU.
THESE TWO MODES ARE:
"1) MACRO OPERATIONS IN THE BACKGROUND - YOU WILL NOT BE ABLE TO OBSERVE THE EXECUTION OF ANY OF THE COMMANDS IN THE MPM MENU. YOU WILL, OF COURSE BE ABLE TO SEE THE FINAL RESULT."
"THIS MODE OF OPERATION WILL NOT BE AS ENTERTAINING TO SOME USERS, BUT THE COMMANDS IN THE MPM MENU WILL RUN FASTER THAN…"
"2) SHOW ALL MACRO OPERATIONS - YOU WILL BE ABLE TO SEE THE MPM MENU COMMANDS AS THEY EXECUTE. THIS WILL SLOW DOWN THE COMMANDS, BUT MAY BE USEFUL OR ENTERTAINING FOR SOME USERS."
YOU CAN SWITCH BETWEEN THESE TWO MODES BY SIMPLY SELECTING THE COMMAND JUST ABOVE THE “REMOVE MENU…” COMMAND IN THE MPM MENU. THIS MENU ITEM WILL DISPLAY THE MODE IN WHICH YOU WILL BE RUNNING.
"WHEN YOU QUIT THE PROGRAM (OR MICROSOFT EXCEL, FOR THAT MATTER), THE LAST SETTING OF THIS COMMAND WILL BE SAVED AUTOMATICALLY, SO YOU WON’T HAVE TO RESET YOUR MODE OF OPERATION EVERY TIME."
*25
THIS WILL REMOVE THE MRC MENU.
"TO PUT THE MENU BACK, TYPE OPTION-COMMAND-M."
*26
"THIS COMMAND WILL OPEN A SAMPLE PORTFOLIO, AND DIRECT YOU TO USE IT JUST AS YOU WOULD A REAL PORTFOLIO OF ITEMS."
"YOU WILL BE ASKED TO UPDATE THE PRICES OF THE ITEMS THAT HAVE ALREADY BEEN ENTERED FOR YOU. THEN, YOU WILL BE SHOWN HOW TO ADD A NEW ITEM TO THIS PORTFOLIO, MODIFY IT, AND REMOVE IT."
"IF YOU NEED FURTHER ASSISTANCE, YOU ARE ENCOURAGED TO CONSULT THE USER MANUAL, WHICH HAS DETAILED INSTRUCTIONS ON EVERY COMMAND IN MARK’S PORTFOLIO MANAGER."
*27
YOU SELECTED HELP ON HELP. JUST PICK THE HELP OPTION. TRUST ME.
*28
"THIS IS THE COMMAND TO USE IF YOU WISH TO ADD NEW HELP TOPICS. YOU MUST FIRST GIVE YOUR HELP TOPIC A TITLE, AND THEN ENTER THE HELP TEXT."
"YOU CAN EVEN USE THIS COMMAND TO ENTER MESSAGES TO YOURSELF. IF ANY OF THESE MESSAGES OR REMINDERS EXPIRE WITH TIME, JUST GET RID OF THEM WITH THE “REMOVE A HELP TOPIC…” COMMAND."
"IF YOU ARE ADDING NEW HELP TOPICS FOR THE FIRST TIME, PLEASE READ THE DIALOG BOXES CAREFULLY, AS THEY CONTAIN USEFUL INSTRUCTIONS CONCERNING HOW TO ADD NEW HELP TOPICS."
*29
THIS IS THE COMMAND TO REMOVE ANY HELP TOPIC THAT APPEARS IN THE DIALOG BOX THAT DESCRIBES HELPTOPICS FOR THIS PROGRAM.
"JUST CLICK ON THE HELP TOPIC THAT YOU WANT TO DELETE, AND THE PROGRAM WILL TAKE CARE OF THE REST."
THIS MAY TAKE A BIT LONGER THAN YOU WOULD EXPECT. THIS IS NORMAL. THE PROGRAM IS DOING SOME INTERNAL HOUSEKEEPING THAT SHOULD ONLY TAKE A FEW MOMENTS. THANK YOU IN ADVANCE FOR YOUR PATIENCE.
*30
"IF YOU SEE THAT ANY CELLS IN ANY DOCUMENT CONTAIN A “#REF!”, THEN THIS MEANS THAT THE CELL CONTAINS A REFERENCE THAT EXCEL CANNOT INTERPRET. CONSIDER THE FOLLOWING REASONS FOR THIS:"
1) HAVE YOU RENAMED A FOLDER WHEN YOU ARE AT THE FINDER THAT CONTAINS ANY DOCUMENTS THAT THE PROGRAM NEEDS TO LOOK FOR??
"IF YOU HAVE, THEN YOU WILL NEED TO EITHER MANUALLY CHANGE ALL OF THE FORMULAS TO REFLECT THE NEW FOLDER NAME, OR SELECT “LINKS...” FROM THE FILE MENU AND CHANGE THE NAME THAT WAY."
2) HAVE YOU CHANGED ANY OF THE DOCUMENT NAMES THAT ARE REFFERED TO IN THE WORKSHEET??
"IF THIS IS TRUE, THEN FOLLOW THE DIRECTIONS ABOVE FOR CHANGING THE LINKS TO OTHER EXCEL FILES."
3) DID YOU START BY CLICKING ON STOCKS RATHER THAN STOCKS MACRO??
"IN SOME VERSIONS OF EXCEL, IF YOU START BY DOUBLE-CLICKING ON A DOCUMENT OTHER THAN STOCKS MACRO, YOU WILL BE ASKED IF YOU WANT TO OPEN REFERENCES TO UNOPENED DOCUMENTS."
"IN SOME VERSIONS OF EXCEL, IF YOU REPLY “NO” TO THIS QUESTION, EXCEL WILL PUT “#REF!” IN ALL OF THE LINKED CELLS."
YOU CAN FIX THIS PROBLEM BY STARTING THE STOCKS PROGRAM BY DOUBLE-CLICKING ON STOCKS MACRO ONLY.
4) IS YOUR CALCULATION MODE SET PROPERLY??
"IF YOU SELECT “CALCULATION...” FROM THE OPTIONS MENU, YOU SHOULD OBSERVE THAT THE CALCULATION MODE IS SET TO “AUTOMATIC”."
"IF IT IS NOT, SOME CELLS MAY DISPLAY A “#REF!”. JUST SELECT THE “AUTOMATIC” OPTION, AND THE PROBLEM SHOULD GO AWAY."
*31
"IF YOU GET AN ERROR STATING THAT EXCEL CAN’T FIND A DOCUMENT, THEN THIS USUALLY MEANS THAT YOU HAVE PUT ONE OF THE DOCUMENTS IN A FOLDER THAT EXCEL DOESN’T KNOW ABOUT."
"WHEN YOU “INSTALL” THE STOCKS PROGRAM, ALL OF THE PORTFOLIOS MUST BE IN THE SAME FOLDER ON YOUR HARD DRIVE. ANYTHING ELSE WILL CAUSE ERRORS IF YOU TRY TO USE THE PROGRAM."
"IF YOU GET THIS ERROR, YOU ARE ADVISED TO QUIT MICROSOFT EXCEL, MOVE THE FILES INTO THE CORRECT PLACE, AND RESTART BY DOUBLE-CLICKING ON THE FILE “STOCKS MACRO”."
*32
"THE MOST COMMON REASON FOR THIS, IS THAT THE FILES FOR EACH ITEM ARE NOT LINKED PROPERLY TO THEIR PORTFOLIOS."
YOU CAN CHECK THESE LINKS BY SELECTING “LINKS” FROM THE FILE MENU.
"IF THIS DOES NOT WORK, MAKE SURE THAT YOUR CALCULATION MODE IS SET TO “AUTOMATIC” BY SELECTING “CALCULATION...” FROM THE OPTIONS MENU."
*33
"IF THE PROGRAM RETURNS AN ERROR MESSAGE STATING THAT THE PORTFOLIO THAT YOU HAVE ASKED FOR DOES NOT EXIST, CONSIDER THE FOLLOWING REASONS WHY THIS IS THE CASE:"
"1) THE PORTFOLIO MAY HAVE BEEN DELETED. IF THIS IS THE CASE, THEN YOU MUST ACTIVATE THE FINDER, LOCATE THE PORTFOLIO, AND RESTORE IT TO ITS PROPER LOCATION."
"2) THE PORTFOLIO MAY EXIST, BUT MAY HAVE BEEN MOVED TO A LOCATION WHERE IT CANNOT BE FOUND BY THE STOCKS PROGRAM. IF THIS IS TRUE, THEN YOU MUST ACTIVATE THE FINDER, LOCATE THE PORTFOLIO, AND MOVE IT TO ITS PROPER LOCATION."
"IN GENERAL, IT IS WISE TO PUT ALL OF THE PORTFOLIOS IN THE SAME FOLDER AS THE STOCKS PROGRAM ITSELF. ANY OTHER PRACTICE MAY LEAD TO ERRORS."
*34
YOU CAN MAKE THIS MISTAKE IN TWO WAYS:
1) YOU HAVE ENTERED THE SAME TRANSACTION ON A GIVEN PORTFOLIO ITEM TWICE.
"IN THIS CASE, YOU MUST DELETE ONE OF THE TRANSACTIONS USING THE “EDIT A PORTFOLIO…” COMMAND."
"2) YOU HAVE ADDED AN ITEM TO A PORTFOLIO TWICE, GIVING THE ITEM A DIFFERENT SYMBOL THAN WHEN YOU ADDED IT FOR THE FIRST TIME."
"IN THIS CASE YOU MUST FIRST DELETE THE ITEM USING THE “EDIT A PORTFOLIO…” COMMAND IN THE MRC MENU. THEN ACTIVATE THE FINDER, OPEN THE FOLDER CALLED “STOCKS SOLD”, AND DRAG THE ICON OF THE ERRANT DOCUMENT TO THE TRASH."
*35
"IF YOU GET AN ERROR MESSAGE, STATING THAT A DIRECTORY OR FOLDER CANNOT BE FOUND, IT IS PROBABLY BECAUSE THE EXCEL ADD-IN “FILE FUNCTIONS” HAS NOT BEEN INSTALLED."
"TO INSTALL THE ADD-IN, SELECT “ADD-INS…” FROM THE OPTIONS MENU, CLICK ON THE “ADD” BUTTON, AND SELECT “FILE FUNCTIONS”."
"THIS ADD-IN IS LOCATED IN YOUR SUBDIRECTORY CALLED “MACRO LIBRARY”. IF IT IS NOT PRESENT, THEN YOU NEED TO COPY IT INTO YOUR EXCEL FOLDER FROM THE INSTALLATION DISKS."
*36
"SINCE THE POSSIBILITY THAT YOU WILL REMEMBER ALL OF THE TRANSACTIONS OF A GIVEN ITEM IS VERY REMOTE, THE BEST SOLUTION IS TO RESTORE THE DRIP FROM A BACKUP."
THIS IS AN EXCELLENT REASON TO KEEP REGULAR BACKUPS OF ALL YOUR FILES.
HAVE YOU THOUGHT ABOUT WHAT YOU WOULD DO IF YOU LOST ALL OF YOUR DATA AT THIS MOMENT??
WHY NOT TAKE A FEW MINUTES AND BACK UP ALL OF YOUR FILES. YOU WILL THANK YOURSELF LATER.
*37
MICROSOFT HAS ACKNOWLEGED THAT THERE IS A PROBLEM WITH THE ADD-IN FUNCTION THAT WILL DELETE A DIRECTORY.
"IF YOU FIND THAT THE DIRECTORY OF AN OLD PORTFOLIO IS NOT DELETED, YOU MUST DELETE IT YOURSELF AT THE FINDER."
"FOR MORE INFORMATION, READ THE MICROSOFT EXCEL KNOWLEDGE BASE DOCUMENT Q105211, PUBLISHED 11/4/93."
*38
"IF THE ANNUAL RETURN FIGURE THAT APPEARS IN THE DIALOG BOX DOES NOT MAKE SENSE, CONSIDER YOUR TRADING PATTERN IN THAT ITEM."
"IF YOU TRADE FREQUENTLY IN A GIVEN STOCK, FUND, OR COMMODITY, AND YOU GO FROM A LONG TO A SHORT POSITION OFTEN, THEN ANNUAL RETURN FIGURES MAY NOT ALWAYS MAKE SENSE."
"IF THIS IS A BOTHER, CONSIDER SPLITTING UP YOUR TRADE FROM LONG TO SHORT."
"FOR EXAMPLE, IF YOU OWN 100 SHARES OF XYZ CORPORATION, AND SELL 200 SHARES, ASSUMING A NET SHORT POSITION, DIVIDE YOUR TRADE SO THAT YOU CLOSE OUT YOUR LONG POSITION, AND RE-ENTER THE TRADE, NET SHORT 100 SHARES."
"THIS MAY NOT BE THE BEST SOLUTION FOR YOU, BUT IT IS THE ONLY WAY THAT YOU WILL BE ABLE TO PRESERVE THE INTEGRITY OF YOUR ANNUAL RETURN FORMULAS."
*39
YOU SHOULD KNOW THAT YOUR MACINTOSH (NOT MICROSOFT EXCEL) IMPOSES A LIMIT ON THE NUMBER OF EXCEL DOCUMENTS THAT YOU CAN OPEN.
"THIS NUMBER IS “APPROXIMATELY 32”, ACCORDING TO THE MICROSOFT EXCEL KNOWLEDGE BASE, TECHNICAL NOTE #Q51310."
"THIS MEANS THAT THE TOTAL NUMBER OF PORTFOLIOS PLUS THE NUMBER OF ITEMS IN THOSE PORTFOLIOS SHOULD NOT EXCEED 31, SINCE THE DOCUMENT “STOCKS MACRO” IS ALWAYS OPEN."
"THEREFORE, YOU NEED TO MANAGE YOUR STARTUP GROUP SO THAT YOU DO NOT EXCEED THIS LIMIT."
"IT MAY BE POSSIBLE TO USE A TOOL LIKE ResEdit TO MODIFY YOUR ENVIRONMENT TO ALLOW FOR MORE DOCUMENTS, BUT IF YOU USE ResEdit, YOU ARE ON YOUR OWN!! (INSIST ON MAKING A BACKUP OF ANYTHING THAT YOU WORK ON IN ResEdit.)"
